package com.cmb.constant;

import lombok.Data;

@Data
public class CreateTableConstant {

    public static final String CREATE_SQL = "create table %s (" +
            "%s) TABLESPACE TBS_CUR_DAT;";

    public static final String COMMENT_TABLE_SQL = "COMMENT ON TABLE %s IS \'%s\';" + System.lineSeparator();

    public static final String COMMENT_COLUMN_SQL = "COMMENT ON COLUMN %s IS \'%s\';" + System.lineSeparator();

    public static final String GRANT_SQL = "GRANT select,update,delete,insert ON %s TO app1;" +  System.lineSeparator() +
            "GRANT select,update,delete,insert ON %s TO app2;" +  System.lineSeparator()+
            "GRANT select,update,delete,insert ON %s TO appbatch;";

    public static final String CREATE_SEQ_SQL = "CONSTRAINT  %s PRIMARY KEY (%s)" + System.lineSeparator();

    public static final String FILE_NAME = "create_%s_table.sql";

}
